1 <?php
2 session_start(); // Use session variable on this page. This function must put on the top of page.
3 if(!isset($_SESSION['username']) || $_SESSION['usertype'] !='admin'){ // if session variable "username" does not exist.
4 header("location:index.php?msg=Please%20login%20to%20access%20admin%20area%20!"); // Re-direct to index.php
5 }
6 else
7 {
8 include_once "db.php";
9
10 ?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
11 "http://www.w3.org/TR/html4/loose.dtd">
12 <html>
13 <head>
14 <title>Welcome to Stock Management System !</title>
15 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
16 <link rel="stylesheet" href="css/validationEngine.jquery.css" type="text/css" media="screen" title="no title" charset="utf-8" />
17 <link rel="stylesheet" href="css/template.css" type="text/css" media="screen" title="no title" charset="utf-8" />
18 <script src="js/jquery.min.js" type="text/javascript"></script>
19
20 <script type='text/javascript' src='lib/jquery.bgiframe.min.js'></script>
21 <script type='text/javascript' src='lib/jquery.ajaxQueue.js'></script>
22 <script type='text/javascript' src='lib/thickbox-compressed.js'></script>
23 <script type='text/javascript' src='jquery.autocomplete.js'></script>
24 <script type='text/javascript' src='localdata.js'></script>
25
26 <link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" />
27 <link rel="stylesheet" type="text/css" href="lib/thickbox.css" />
28
29 <script type="text/javascript">
30 $().ready(function() {
31
32 function log(event, data, formatted) {
33 $("<li>").html( !data ? "No match!" : "Selected: " + formatted).appendTo("#result");
34 }
35
36 function formatItem(row) {
37 return row[0] + " (<strong>id: " + row[1] + "</strong>)";
38 }
39 function formatResult(row) {
40 return row[0].replace(/(<.+?>)/gi, '');
41 }
42
43
44
45 $("#singleBirdRemote").autocomplete("search.php", {
46 width: 160,
47 autoFill: true,
48 selectFirst: false
49 });
50 $("#suplier").autocomplete("search.php", {
51 width: 160,
52 autoFill: true,
53 selectFirst: false
54 });
55 $("#uom").autocomplete("search.php", {
56 width: 160,
57 autoFill: true,
58 selectFirst: false
59 });
60
61
62 $("#clear").click(function() {
63 $(":input").unautocomplete();
64 });
65 });
66
67
68 </script>
69
70 <script src="js/jquery.validationEngine-en.js" type="text/javascript"></script>
71 <script src="js/jquery.validationEngine.js" type="text/javascript"></script>
72 <script src="js/jquery.hotkeys-0.7.9.js"></script>
73 <!-- AJAX SUCCESS TEST FONCTION
74 <script>function callSuccessFunction(){alert("success executed")}
75 function callFailFunction(){alert("fail executed")}
76 </script>
77 -->
78
79 <script>
80
81
82
83
84
85 $(document).ready(function() {
86 // SUCCESS AJAX CALL, replace "success: false," by: success : function() { callSuccessFunction() },
87 $("#name").focus();
88 $("#form1").validationEngine(),
89
90 jQuery(document).bind('keydown', 'Ctrl+s',function() {
91 $('#form1').submit();
92 return false;
93 });
94
95 jQuery(document).bind('keydown', 'Ctrl+r',function() {
96 $('#form1').reset();
97 return false;
98 });
99 jQuery(document).bind('keydown', 'Ctrl+a',function() {
100 window.location = "addstock.php";
101 return false;
102 });
103 jQuery(document).bind('keydown', 'Ctrl+0',function() {
104 window.location = "index.php";
105 return false;
106 });
107 jQuery(document).bind('keydown', 'Ctrl+1',function() {
108 window.location = "addstock.php";
109 return false;
110 });
111 jQuery(document).bind('keydown', 'Ctrl+2',function() {
112 window.location = "dsfsd.php";
113 return false;
114 });
115 //$.validationEngine.loadValidation("#date")
116 //alert($("#formID").validationEngine({returnIsValid:true}))
117 //$.validationEngine.buildPrompt("#date","This is an example","error") // Exterior prompt build example // input prompt close example
118 //$.validationEngine.closePrompt(".formError",true) // CLOSE ALL OPEN PROMPTS
119 });
120 </script>
121 <style type="text/css">
122 <!--
123 body {
124 margin-left: 0px;
125 margin-top: 0px;
126 margin-right: 0px;
127 margin-bottom: 0px;
128 }
129
130 *{
131 padding: 0px;
132 margin: 0px;
133 }
134 #vertmenu {
135 font-family: Verdana, Arial, Helvetica, sans-serif;
136 font-size: 100%;
137 width: 160px;
138 padding: 0px;
139 margin: 0px;
140 }
141
142 #vertmenu h1 {
143 display: block;
144 background-color:#FF9900;
145 font-size: 90%;
146 padding: 3px 0 5px 3px;
147 border: 1px solid #000000;
148 color: #333333;
149 margin: 0px;
150 width:159px;
151 }
152
153 #vertmenu ul {
154 list-style: none;
155 margin: 0px;
156 padding: 0px;
157 border: none;
158 }
159 #vertmenu ul li {
160 margin: 0px;
161 padding: 0px;
162 }
163 #vertmenu ul li a {
164 font-size: 80%;
165 display: block;
166 border-bottom: 1px dashed #C39C4E;
167 padding: 5px 0px 2px 4px;
168 text-decoration: none;
169 color: #666666;
170 width:160px;
171 }
172
173 #vertmenu ul li a:hover, #vertmenu ul li a:focus {
174 color: #000000;
175 background-color: #eeeeee;
176 }
177
178 -->
179 </style>
180 </head>
181
182 <body>
183 <table width="100%" border="0" cellspacing="0" cellpadding="0">
184 <tr>
185 <td align="center" valign="top"><table width="960" border="0" cellspacing="0" cellpadding="0">
186 <tr>
187 <td><table width="960" border="0" cellspacing="0" cellpadding="0">
188 <tr>
189 <td height="90" align="left" valign="top"><img src="images/topbanner.jpg" width="960" height="82"></td>
190 </tr>
191 <tr>
192 <td height="800" align="left" valign="top"><table width="960" border="0" cellspacing="0" cellpadding="0">
193 <tr>
194 <td width="130" align="left" valign="top">
195
196 <br>
197
198 <strong>Welcome <font color="#3399FF"><?php echo $_SESSION['username']; ?> !</font></strong><br> <br>
199 <table width="100%" border="0" cellspacing="0" cellpadding="0">
200 <tr>
201 <td align="center"><a href="admin.php"><img src="images/home.png" width="130" height="99" border="0"></a></td>
202 </tr>
203 <tr>
204 <td align="center"> </td>
205 </tr>
206 <tr>
207 <td align="center"><a href="add_purchase.php"><img src="images/purchase.png" width="130" height="124" border="0"></a></td>
208 </tr>
209 <tr>
210 <td align="center"> </td>
211 </tr>
212 <tr>
213 <td align="center"><a href="add_stock_sales.php"><img src="images/sales.png" width="146" height="111" border="0"></a></td>
214 </tr>
215 <tr>
216 <td align="center"> </td>
217 </tr>
218 <tr>
219 <td align="center"><a href="report.php"><img src="images/reports.png" width="131" height="142" border="0"></a></td>
220 </tr>
221 <tr>
222 <td align="center"> </td>
223 </tr>
224 <tr>
225 <td align="center"> </td>
226 </tr>
227 <tr>
228 <td align="center"> </td>
229 </tr>
230 </table>
231
232
233 <div id="vertmenu">
234 <h1>Options</h1>
235 <ul>
236 <li><a href="admin.php" tabindex="1">Admin Home</a></li>
237 <li><a href="add_purchase.php" tabindex="2">Add Stock Entry</a></li>
238 <li><a href="add_stock_sales.php" tabindex="3">AddStock Sales</a></li>
239 <li><a href="add_stock_details.php" tabindex="4">Add Stock Details</a></li>
240 <li><a href="add_category.php" tabindex="5">Add Catetogry</a></li>
241 <li><a href="add_supplier_details.php" tabindex="6">Add Supplier Details</a></li>
242 <li><a href="add_customer_details.php" tabindex="7">Add Customer Details</a></li>
243
244 <li><a href="view_stock_entries.php" tabindex="8">View Stock Entries</a></li>
245 <li><a href="view_stock_sales.php" tabindex="9">View Stock Sales</a></li>
246 <li><a href="view_stock_details.php" tabindex="10">View Stock Details</a></li>
247 <li><a href="view_supplier_details.php" tabindex="11">View Supplier Details</a></li>
248 <li><a href="view_customer_details.php" tabindex="12">View Customer Details</a></li>
249
250 <li><a href="report.php" tabindex="13">Report</a></li>
251 <li><a href="logout.php" tabindex="14">Signout</a></li>
252 </ul>
253 </div>
254
255
256 </td> <td height="500" align="center" valign="top">
257 <table width="100%" border="0" cellspacing="0" cellpadding="0">
258 <tr>
259 <td><a href="add_stock_details.php"><img src="images/addstockdetails.png" width="67" height="62" border="0"></a></td>
260 <td><a href="add_supplier_details.php"><img src="images/supplier.png" width="67" height="54" border="0"></a></td>
261 <td><a href="add_customer_details.php"><img src="images/customer.png" width="67" height="54" border="0"></a></td>
262 <td><a href="add_category.php"><img src="images/categories.png" width="67" height="54" border="0"></a></td>
263 <td><a href="view_stock_sales.php"><img src="images/vsales.png" width="67" height="54" border="0"></a></td>
264 <td><a href="view_stock_entries.php"><img src="images/vpurchase.png" width="67" height="54" border="0"></a></td>
265 <td><a href="view_stock_details.php"><img src="images/stockdetails.png" width="67" height="54" border="0"></a></td>
266 <td><a href="view_stock_availability.php"><img src="images/savail.png" width="67" height="54" border="0"></a></td>
267 <td align="left" valign="top"><a href="view_customer_details.php"><img src="images/customers.png" width="94" height="22" border="0"></a><br> <a href="view_supplier_details.php"><img src="images/suppliers.png" width="94" height="22" border="0"></a><br>
268 <a href="view_payments.php"><img src="images/payments.png" width="94" height="22" border="0"></a></td>
269 <td align="left" valign="top"><a href="view_stock_sales_payments.php"><img src="images/outstanding.png" width="94" height="22" border="0"></a><br> <a href="view_stock_entries_payments.php"><img src="images/pendings.png" width="94" height="22" border="0"></a><br>
270 <a href="logout.php"><img src="images/logout.png" width="94" height="22" border="0"></a></td>
271 </tr>
272 </table>
273 <?php
274 if(isset($_POST['name']))
275
276 {
277
278 $id=mysql_real_escape_string($_POST['id']);
279 $name=mysql_real_escape_string($_POST['name']);
280 $category=mysql_real_escape_string($_POST['category']);
281 $buyingrate=mysql_real_escape_string($_POST['buyingrate']);
282 $sellingrate=mysql_real_escape_string($_POST['sellingrate']);
283 $suplier=mysql_real_escape_string($_POST['suplier']);
284 $uom=mysql_real_escape_string($_POST['uom']);
285 $expiry=mysql_real_escape_string($_POST['expiry']);
286 $count = $db->countOf("stock_details", "stock_id='$id'");
287 if($count==1)
288 {
289 echo "<font color=red> Dublicat Entry. Please Verify</font>";
290 }
291 else
292 {
293
294 if($db->query("insert into stock_details(stock_id,stock_name,stock_quatity,supplier_id,company_price,selling_price,category,expire_date,uom) values('$id','$name',0,'$suplier',$buyingrate,$sellingrate,'$category','$expiry','$uom')"))
295 echo "<br><font color=green size=+1 >Stock Details Added !</font>" ;
296 else
297 echo "<br><font color=red size=+1 >Problem in Adding !</font>" ;
298
299 }
300
301
302 }
303
304 ?>
305
306 <br>
307 <br>
308
309
310 <form name="form1" method="post" id="form1" action="">
311
312 <p align="center"><strong>Add New Stock Details </strong> - Add New ( Control +A)</p>
313 <table width="300" border="0" cellspacing="0" cellpadding="0">
314 <tr>
315 <td width="150"> </td>
316 <td width="150"> </td>
317 </tr>
318 <tr>
319 <td width="150"> </td>
320 <td width="150"> </td>
321 </tr>
322 <tr>
323 <td width="150">ID</td>
324 <td width="150"><input name="id" type="text" id="id" ></td>
325 </tr>
326 <tr>
327 <td width="150"> </td>
328 <td width="150"> </td>
329 </tr>
330 <tr>
331 <td width="150">Name</td>
332 <td width="150"><input name="name" type="text" id="name" class="validate[required,length[0,100]] text-input"></td>
333 </tr>
334 <tr>
335 <td width="150"> </td>
336 <td width="150"> </td>
337 </tr>
338 <tr>
339 <td width="150">Category</td>
340 <td width="150"><input name="category" type="text" id="singleBirdRemote"></td>
341 </tr>
342 <tr>
343 <td> </td>
344 <td> </td>
345 </tr>
346 <tr>
347 <td>Buying Rate</td>
348 <td><input name="buyingrate" type="text" id="buyingrate" class="validate[required,custom[onlyNumber],lengthCheck[6]] text-input" ></td>
349 </tr>
350 <tr>
351 <td> </td>
352 <td> </td>
353 </tr>
354 <tr>
355 <td>Selling Rate </td>
356 <td><input name="sellingrate" type="text" id="sellingrate" class="validate[required,custom[onlyNumber],lengthCheck[6]] text-input" ></td>
357 </tr>
358 <tr>
359 <td> </td>
360 <td> </td>
361 </tr>
362 <tr>
363 <td>Suplier Name</td>
364 <td><input name="suplier" type="text" id="suplier" class="validate[optional,length[0,100]] text-input"></td>
365 </tr>
366 <tr>
367 <td> </td>
368 <td> </td>
369 </tr>
370 <tr>
371 <td>UOM</td>
372 <td><input name="uom" type="text" id="uom" class="validate[optional,length[0,100]] text-input"></td>
373 </tr>
374 <tr>
375 <td> </td>
376 <td> </td>
377 </tr>
378 <tr>
379 <td>Expiry Date </td>
380 <td><input name="expiry" type="text" id="expiry" class="validate[optional,length[0,100]] text-input" ></td>
381 </tr>
382 <tr>
383 <td> </td>
384 <td> </td>
385 </tr>
386 <tr>
387 <td align="right"><input type="reset" name="Reset" value="Reset"> </td>
388 <td>
389 <input type="submit" name="Submit" value="Save"></td>
390 </tr>
391 <tr>
392 <td align="center"> (Control + R) </td>
393 <td align="left"> ( Control + S ) </td>
394 </tr>
395 </table>
396 </form></td>
397 </tr>
398 </table>
399
400 </td>
401 </tr>
402 <tr>
403 <td height="30" align="center"><a href="http://www.pluskb.com">Developed by PlusKB Innovations</a></td>
404 </tr>
405 </table></td>
406 </tr>
407 </table></td>
408 </tr>
409 </table>
410
411 </body>
412 </html>
413 <?php
414 }
415 ?>